#一工作簿下多个sheet表按【列名】合并
import pandas as pd
file = r'C:\Users\xuedong\Desktop\五大联赛.xlsx'
outfile = r'C:\Users\xuedong\Desktop\OUT五大联赛.xlsx'
df = pd.ExcelFile(file)
df_new = pd.DataFrame()
for name in df.sheet_names:
        df_pre = df.parse(sheet_name=name, dtype={'columns_name': str})#精华行
        df_new = df_new.append(df_pre)
df_new.to_excel(outfile, index=False)